/**
 * User: alesj
 * Date: 2004.12.2
 * Time: 16:58:35
 */

package com.generalynx.ecos.data.dao;

public interface IHQLStrings {

    //finds all flow descriptors who have ALL their parameters in values set
    public static final String FIND_FD_IDS = "select fd.id " +
                    "from FlowDescriptorParameter fdp, BasicFlowDescriptor fd " +
                    "where fdp.flowDescriptor = fd " +
                    "and fdp.value in (:values) " +
                    "and fd.source is not null " +
                    "group by fd.id " +
                    "having count(fd.id) = (select count(f) from FlowDescriptorParameter f where f.flowDescriptor = fd)";

}
